load data
 infile 'D:\Userdata\db\university.csv'
 replace
 into table university
 fields terminated by "," optionally enclosed by '"'
 trailing nullcols
  (uname char "TRIM (:uname)", uphone char "TRIM (:uphone)", ustreet char "TRIM (:ustreet)", ucity char "TRIM (:ucity)", uzip char "TRIM (:uzip)")
